<!-- userListSearch.php 用于列出所有用户，并添加了搜索表单。 -->
<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">  
  <title>鲜花列表</title>
 </head>
 <body>
 
 <?php 
  require_once('inc_admin.php');
  //连接数据库  
  connect();
  //编写sql语句
  $sql = "select * from flower  ";

  //如果用户提交了表单，则获取用户输入的关键字
  if(isset($_POST['key']))  {
	  $key = trim($_POST['key']);
	  $sql = $sql." where wyy_title like '%{$key}%' ";
  }
   // echo $sql.'<br/>';  
  $result = fetch_array($sql);    
 ?>

 <center><h3>鲜花列表</h3></center>
 <table align="center" width="80%">
 <tr><td  align="left" >
 <form method=post action="">
    请输入鲜花名：
	<input type="text" name="key">
	<input type="submit" name='search' value="搜索">	
 </form> 
 </td></tr>
 </table>

 <table align="center" width="80%" border=1> 
  <tr>

   <th>id</th>   
   <th>鲜花标题</th>
   <th>鲜花图片文件名</th>
   <th>鲜花产地</th>
   <th>鲜花简介</th>
   <th>添加鲜花的时间</th> 
   <th>点击量</th>
   <th>操作</th>
 </tr>
<?php
  foreach ($result as $row) {
   echo '<tr>';
   echo '<td>'.$row['wyy_id'].'</td>';
   echo '<td><a href="detail.php?id='.$row['wyy_id'].'">'.$row['wyy_title'].'</a></td>';  
   echo '<td>'.($row['wyy_pic']).'</td>';
   echo '<td>'.$row['wyy_place'].'</td>';
   echo '<td>'.$row['wyy_intro'].'</td>';
   echo '<td>'.$row['wyy_adddate'].'</td>';
   echo '<td>'.$row['wyy_hint'].'</td>';    
   echo '<td><a href=" ">修改</a> | 
   <a href="delflower.php?id='.$row['wyy_id'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';
   echo '</tr>';  
  }
  echo '</table>';  
  $totalrows = count($result);
  echo "<table align='center'><tr><td>共有{$totalrows}种鲜花</td></tr></table>";   
 ?>
 </table></center>
 </div>
</div>

 </body>
</html>
